package com.iotechn.unimall.data.mapper;

import com.baomidou.mybatisplus.mapper.BaseMapper;
import com.iotechn.unimall.data.dto.statistics.StoreSkuMonthlyDTO;
import org.apache.ibatis.annotations.Param;

import javax.xml.crypto.Data;
import java.util.Date;
import java.util.List;

/**
 * @author chen
 */
public interface WarehouseGoodsStatisticMapper extends BaseMapper<StoreSkuMonthlyDTO> {
    /**   入库 */
    List<StoreSkuMonthlyDTO> purchaseWarehouseOrder(@Param("startTime") Data startTime, @Param("endTime") Date endTime, @Param("warehouseId") Long warehouseId);
    /** 出库 */
    List<StoreSkuMonthlyDTO> salesSendOrder(@Param("startTime") Data startTime, @Param("endTime") Date endTime, @Param("warehouseId") Long warehouseId);
    /** 退库 */
    List<StoreSkuMonthlyDTO> purchaseOrderReturn(@Param("startTime") Data startTime, @Param("endTime") Date endTime, @Param("warehouseId") Long warehouseId);

    /** 期初 */
    List<StoreSkuMonthlyDTO> warehouseBegin(@Param("statisticTime") Date statisticTime, @Param("warehouseId") Long warehouseId);
    /** 期末 */
    List<StoreSkuMonthlyDTO> warehouseFinal(@Param("statisticTime") Date statisticTime, @Param("warehouseId") Long warehouseId);

}
